insert into histories(visit_id,waktu_datang,urut,petugas_medis,bayar) select visits.id,"2024-03-08 10:06:19",(select ifnull(max(histories.urut)+1, 1) from histories where histories.waktu_datang like "2024-03-08%" limit 1) as urut,workers.nama,"0" from visits left join workers on (visits.entry_id=workers.id) left join typepatients on (visits.typepatient_id=typepatients.id) where visits.tanggal="2024-03-08" order by visits.id desc limit 1 
